UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CWSXHhiq/33MBIwSVyanpOc968iCcCl2fmNXH1xjKnE='
WHERE
key_id = 'dbbb50c04ca919259eae3d4aa546ccb62cd01f9cfbac928fb9cb18b5773e42e9'
AND (
token = 'CWSXHhiq/33MBIwSVyanpOc968iCcCl2fmNXH1xjKnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)