UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YMDEsJ5Rpwasdq43vmlx5ZBmEH6FmXjYXJj0nwwKf8='
WHERE
key_id = '8b0e3e1b09f567f45aef24009e0ed447d2bcc634d23dcb4ce538f24e2c8491d8'
AND (
token = '1YMDEsJ5Rpwasdq43vmlx5ZBmEH6FmXjYXJj0nwwKf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)