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