UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rS7F88wV/MLcF1GFD781i4UU4v1qAd769RJTZx3cwZg='
WHERE
key_id = 'c370e97d14fc8585b3b096f629702135f1acedf56e86cd522cb0a53dbf102a35'
AND (
token = 'rS7F88wV/MLcF1GFD781i4UU4v1qAd769RJTZx3cwZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)