UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8IokLH0XyIRI6Q0+hH7fvLNfWGr27g6IFIJwt6X2S8='
WHERE
key_id = 'dcbcc92cbd4f617c3a018322885e02e2a57c5306a03a5aa524a3a4fba32ed650'
AND (
token = 'a8IokLH0XyIRI6Q0+hH7fvLNfWGr27g6IFIJwt6X2S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)