UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RqVTXY5RUuzFM6XOtQs5PDNhIzASuEB5cn6ph9uGfGU='
WHERE
key_id = 'd8057f84cc10177e1ab0ed0d38cd151912167cc4aa103a2aa65143a3ed861388'
AND (
token = 'RqVTXY5RUuzFM6XOtQs5PDNhIzASuEB5cn6ph9uGfGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)