UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lsHV7Yl3zyYyZpIwf+kCB9B/CRNonKQ86WF4/KW250='
WHERE
key_id = '42c4e6f178d3f4b4522ef21cb0555787b17e3c3f813d5a4b0d29af14199fd8d7'
AND (
token = '6lsHV7Yl3zyYyZpIwf+kCB9B/CRNonKQ86WF4/KW250='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)