UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dnzNc7KzOdMN77EvfwTNU0kaxiKdcVYnaKspgm19Z/8='
WHERE
key_id = 'cdaf88ed0636430619db32c2cdc760007d52a06541282746fb8c607dcfa67e45'
AND (
token = 'dnzNc7KzOdMN77EvfwTNU0kaxiKdcVYnaKspgm19Z/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)