UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mMj4AWS2kmUfzsT0h3kPBNdlSyc+Y1PuEcCRxlle9uE='
WHERE
key_id = 'ec8181e47143bd6791119af16361ef4a326123055632c3cd9ab26635a1ff7189'
AND (
token = 'mMj4AWS2kmUfzsT0h3kPBNdlSyc+Y1PuEcCRxlle9uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)