UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zAPv1cK9ep/IJxUZ/ncEcTyFS6zlltW9cWMXq2U8UQ='
WHERE
key_id = 'bd539a26a04ffab5a2c72f8b8ba9182a34f9c75053f345e21f0e5cc3623b3513'
AND (
token = '2zAPv1cK9ep/IJxUZ/ncEcTyFS6zlltW9cWMXq2U8UQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)