UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lxRWysH+T9p3c4ohkDBUo8LnmnrNbCOKImqRBY3vN0='
WHERE
key_id = 'e06de47c1b9f2c2b9bbd321848706a97979d9c1ad232f08bd6323148c52f4263'
AND (
token = '4lxRWysH+T9p3c4ohkDBUo8LnmnrNbCOKImqRBY3vN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)