UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lWXh6Qoi7M2jSgfDGG6pT9SK7sICigXtYn4brp6HU8='
WHERE
key_id = '24313b8319c37da44af7e04a369af0b90521b696126c6f49b01d55aad278ac30'
AND (
token = '6lWXh6Qoi7M2jSgfDGG6pT9SK7sICigXtYn4brp6HU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)