UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PQ7czgP5V2p9YwbGjEbmFMxCDUKW4j7U4UQp+ZRVEHc='
WHERE
key_id = 'e5ca42cc29af7b631fea669d251a8eca8eee4f5d17b95784da60edca350f75d5'
AND (
token = 'PQ7czgP5V2p9YwbGjEbmFMxCDUKW4j7U4UQp+ZRVEHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)