UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqD3fWVAJLG+k5dHWBNxipQJqeje0lkCGsE2ta5xPwA='
WHERE
key_id = 'c5538bdc831a3bf5480889be81a2c481e39a9891a93b64e8c3565e2124d39373'
AND (
token = 'BqD3fWVAJLG+k5dHWBNxipQJqeje0lkCGsE2ta5xPwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)