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