UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7h4k33OhSzep1UEzetRo9X6bnbmfvU9bpBtrdljubPA='
WHERE
key_id = '5907c058f83d8aa556fdf2e803b83eedc2ddacea9f0e75b3c53750404574cee8'
AND (
token = '7h4k33OhSzep1UEzetRo9X6bnbmfvU9bpBtrdljubPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)