UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6Qsur7kk7FituqhH0jkvbIRtnilBkxe6iUxs8eFzCo='
WHERE
key_id = 'dbcaba257c5083790f15b456ba2f043d435699c92839f29ba87bd2cba837908d'
AND (
token = 'B6Qsur7kk7FituqhH0jkvbIRtnilBkxe6iUxs8eFzCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)