UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NOahkl3t0YsENTbqQV42WTE84MCD5ZF6Ek24qBB/J34='
WHERE
key_id = '48c8cc5f620525bf04c4a76c3f291399b57064735651861d5752f5ef38db5125'
AND (
token = 'NOahkl3t0YsENTbqQV42WTE84MCD5ZF6Ek24qBB/J34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)