UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQxH0nsnxJ8OMLLsXYCXLbMYjdNf4AbfWtYBsulFttY='
WHERE
key_id = '2a5aca6fc80d3d8ae4b017103f148f25e788340ed53e1bf47d16da20f1f72df9'
AND (
token = 'XQxH0nsnxJ8OMLLsXYCXLbMYjdNf4AbfWtYBsulFttY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)