UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YgDC6RjStNCy2/XhDc93jx3BQbYG0XtUXJjl6gPjAA='
WHERE
key_id = 'c1a72e5ff08c74e738ca961fce2a28d1a44115f1747c25f82543cc7b08699e8b'
AND (
token = '9YgDC6RjStNCy2/XhDc93jx3BQbYG0XtUXJjl6gPjAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)