UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pSB0PwmoxYkqABnGEaR/GtnwLXphjYHiy5ftVobCXM='
WHERE
key_id = '6c5db485c9f9083c25a54a09bcd156361a0f92fce3108cc8c432b0ac8b8585ae'
AND (
token = '0pSB0PwmoxYkqABnGEaR/GtnwLXphjYHiy5ftVobCXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)