UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxtLIXZXhAC5mfrcaxZrPaom45hUf91cBE92iLdaBYU='
WHERE
key_id = '9301da2dbaf3cee8c5944fdabd24e50de533c3659c21c2aeba811cd72d2a3696'
AND (
token = 'zxtLIXZXhAC5mfrcaxZrPaom45hUf91cBE92iLdaBYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)