UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXAiMeEyJP06M1ZwrnPAZ4Q9fQa7JSxC/1e94cSEjfU='
WHERE
key_id = '2f82f3b1fa433ca8180a5e8b4542b1cb8a9c13b1c529531a1ef6bd3d50db5d5b'
AND (
token = 'hXAiMeEyJP06M1ZwrnPAZ4Q9fQa7JSxC/1e94cSEjfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)