UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clzIuf90B7OySl17eGKVR7dWYWMZ9d+BRWR8F1Zn23w='
WHERE
key_id = 'ce6a35d9805d676877b57d47063c7e3c04a915d0b812eb9f7d060256d6fdae50'
AND (
token = 'clzIuf90B7OySl17eGKVR7dWYWMZ9d+BRWR8F1Zn23w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)