UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPY8glIPvaqQOiw6Mkhr2iGrLIHuLRaqf1v+K/DeDpE='
WHERE
key_id = 'bfe149413feeae6c7e7026515864c4ddf5fdf18f96efdad4905f537d5812f33c'
AND (
token = 'lPY8glIPvaqQOiw6Mkhr2iGrLIHuLRaqf1v+K/DeDpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)