UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hvywGx2QjjHFz7hbq2ThwnGjjUZ/aCSBESirCVgK1c='
WHERE
key_id = '27e0c701766d2307ae24b6986679c0ba76893498a8acf6577cbd5c8b06b2bd2f'
AND (
token = '2hvywGx2QjjHFz7hbq2ThwnGjjUZ/aCSBESirCVgK1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)