UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I3+KinEVnrgpiOGDZmr0+bXy2n8T+YmfuGAx8y5huAk='
WHERE
key_id = '3a65120206f2b6362f0e687bec30516591d5a1097c31ac571e11499043ea9ae3'
AND (
token = 'I3+KinEVnrgpiOGDZmr0+bXy2n8T+YmfuGAx8y5huAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)