UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gAul0XTvq7vAj2+g/599cEm4tgrGnvmYJakO5jvBz/k='
WHERE
key_id = 'ec0468318f2860003fc5069f4ee7cdffcf940d614d0448ca19cb0cd8635cd243'
AND (
token = 'gAul0XTvq7vAj2+g/599cEm4tgrGnvmYJakO5jvBz/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)