UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gl8ofgLul/Zks2fOcY6PtIn0gylUtI8cuDm1K1+Ye80='
WHERE
key_id = '1df037853c98a0268c2a9b1ff355f5516719be6ee5a06aa8b30a64dab84dea4c'
AND (
token = 'gl8ofgLul/Zks2fOcY6PtIn0gylUtI8cuDm1K1+Ye80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)