UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kDVsCCZIwyIGNyVeLW5m0VTTOh0fBhwWunX+lr6eInM='
WHERE
key_id = 'c9c1d842eb36143b778cc106adccbd8baa7b083f9ba73e255665f180c416210c'
AND (
token = 'kDVsCCZIwyIGNyVeLW5m0VTTOh0fBhwWunX+lr6eInM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)