UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5D8flAL4knwLGxEt34e9iVJVDVd1UzjIHHw6JuFBEk='
WHERE
key_id = 'd53fca8517783efbe024113017872663a55d90ed59437d5ab797f98544213125'
AND (
token = 'X5D8flAL4knwLGxEt34e9iVJVDVd1UzjIHHw6JuFBEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)