UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0BvCEqSPx/LT0cu3+glAbSV0Qp6fr/QYvWop4ev8tw='
WHERE
key_id = '4d795882659106e4839fddee18cb70e17df02b9a8eb725afce2e88ed0be859c4'
AND (
token = 'R0BvCEqSPx/LT0cu3+glAbSV0Qp6fr/QYvWop4ev8tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)