UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BThHe8sTNl5bMOUpSW63Lj0nDO7no/HLxGLSPMMvYbo='
WHERE
key_id = '1adec38c1d2057fe2a4e34b550a9242ac7c0c27423f23ee087ef8d2c2ccbbbdb'
AND (
token = 'BThHe8sTNl5bMOUpSW63Lj0nDO7no/HLxGLSPMMvYbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)