UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cdznjyFj+nG/8RbTHodEvzR7XwsAfaC25GeG7gt/3uI='
WHERE
key_id = '46797d47c2ca724b48a66c854080c011a344ebc43d68e043250c1a78bcc2dc22'
AND (
token = 'cdznjyFj+nG/8RbTHodEvzR7XwsAfaC25GeG7gt/3uI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)